package com.mc.dao;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;

import com.mc.model.Teacher;

public interface TeacherMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(Teacher record);

    int insertSelective(Teacher record);

    Teacher selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(Teacher record);

    int updateByPrimaryKey(Teacher record);
    //NAME1 VARCHAR(30),NO1 VARCHAR(20),gender1 char(2),major_id1 int ,
   // phone1 VARCHAR(20),qq1 VARCHAR(15),teachertypeid int,userid int 
    void insertTeacher(Map<String,Object>params);
    /**
     * 得到所有计科教师
     * @return
     */
    List<Teacher> selectAllcteachers();
    /**
     * 得到所有软工教师
     * @return
     */
    List<Teacher> selectAllrteachers();
    /**
     * 得到所有信科教师
     * @return
     */
    List<Teacher> selectAllxteachers();
    /**
     * 得到所有应用数学教师
     * @return
     */
    List<Teacher> selectAllyteachers();
    /**
     * 得到所有物联网教师
     * @return
     */
    List<Teacher> selectAllwteachers();
    
    void del_teacher(@Param("tid") int tid,@Param("uid") int uid);
    
    List<Teacher> selectBylabid(@Param("id")int id); 
    
    List<Teacher> selectfjs();
    
    List<Teacher> selectjs();
    /**
     * 查找所有的教师信息
     * @return
     */
    List<Teacher> selectAllTeacher();
    /**
     * 根据部门id和教师职位查找教师信息
     * @param departmentid 部门id
     * @param position 职位
     * @return
     */
    List<Teacher> selectbypositionadid(@Param("departmentid")int departmentid,@Param("position")String position);
    /**
     * 根据部门id查找教师
     * @param did 部门id
     * @return 教师集合
     */
    List<Teacher> selectbydid(int did);
    
    /**
     * 根据专业id查找教师
     * @param id 专业id
     * @return 教师集合
     */
    List<Teacher> selectAllteacherbymajorid(Integer id);
    
    Teacher selectbypositionabid(@Param("rlabid")int rlabid,@Param("position")String position);
    
    List<Teacher> selectbybid(int bid);
} 